﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="OrcamentoDataSet" targetNamespace="http://tempuri.org/OrcamentoDataSet.xsd" xmlns:mstns="http://tempuri.org/OrcamentoDataSet.xsd" xmlns="http://tempuri.org/OrcamentoDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ReportConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ReportConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ReportConnectionString.ConnectionString" Provider="MySql.Data.MySqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrcamentoHeaderTableAdapter" GeneratorDataComponentClassName="OrcamentoHeaderTableAdapter" Name="OrcamentoHeader" UserDataComponentName="OrcamentoHeaderTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        orcamento.IdOrcamento, orcamento.IdCliente, orcamento.DataSolic, orcamento.DataExec, orcamento.DataValid, orcamento.Obs, orcamento.Status, 
                         cliente.Tipo, cliente.Nome, cliente.Sobrenome, cliente.NomePJ
FROM            orcamento INNER JOIN
                         cliente ON orcamento.IdCliente = cliente.IdCliente
WHERE        (orcamento.IdOrcamento = @idOrcamento)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="idOrcamento" ColumnName="IdOrcamento" DataSourceName="deo.orcamento" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@idOrcamento" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdOrcamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdOrcamento" DataSetColumn="IdOrcamento" />
              <Mapping SourceColumn="IdCliente" DataSetColumn="IdCliente" />
              <Mapping SourceColumn="DataSolic" DataSetColumn="DataSolic" />
              <Mapping SourceColumn="DataExec" DataSetColumn="DataExec" />
              <Mapping SourceColumn="DataValid" DataSetColumn="DataValid" />
              <Mapping SourceColumn="Obs" DataSetColumn="Obs" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="Tipo" DataSetColumn="Tipo" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Sobrenome" DataSetColumn="Sobrenome" />
              <Mapping SourceColumn="NomePJ" DataSetColumn="NomePJ" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrcamentoItensTableAdapter" GeneratorDataComponentClassName="OrcamentoItensTableAdapter" Name="OrcamentoItens" UserDataComponentName="OrcamentoItensTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        orcamentoitem.IdOrcamentoItem, subfamilia.SubFamilia, produto.Referencia, produto.Produto, orcamentoitem.Quantidade, produto.Unidade, 
                         orcamentoitem.ValorUnit, orcamentoitem.ValorTotal, produto.Medida, produto.Embalagem, produto.Caixa, produto.Cor, produto.IPI, orcamentoitem.Obs
FROM            orcamentoitem INNER JOIN
                         produto ON orcamentoitem.IdProduto = produto.IdProduto INNER JOIN
                         subfamilia ON produto.IdSubFamilia = subfamilia.IdSubFamilia
WHERE        (orcamentoitem.IdOrcamento = @idOrcamento)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="idOrcamento" ColumnName="IdOrcamento" DataSourceName="deo.orcamentoitem" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@idOrcamento" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdOrcamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdOrcamentoItem" DataSetColumn="IdOrcamentoItem" />
              <Mapping SourceColumn="SubFamilia" DataSetColumn="SubFamilia" />
              <Mapping SourceColumn="Referencia" DataSetColumn="Referencia" />
              <Mapping SourceColumn="Produto" DataSetColumn="Produto" />
              <Mapping SourceColumn="Quantidade" DataSetColumn="Quantidade" />
              <Mapping SourceColumn="Unidade" DataSetColumn="Unidade" />
              <Mapping SourceColumn="ValorUnit" DataSetColumn="ValorUnit" />
              <Mapping SourceColumn="ValorTotal" DataSetColumn="ValorTotal" />
              <Mapping SourceColumn="Medida" DataSetColumn="Medida" />
              <Mapping SourceColumn="Embalagem" DataSetColumn="Embalagem" />
              <Mapping SourceColumn="Caixa" DataSetColumn="Caixa" />
              <Mapping SourceColumn="Cor" DataSetColumn="Cor" />
              <Mapping SourceColumn="IPI" DataSetColumn="IPI" />
              <Mapping SourceColumn="Obs" DataSetColumn="Obs" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HomeDiarioTableAdapter" GeneratorDataComponentClassName="HomeDiarioTableAdapter" Name="HomeDiario" UserDataComponentName="HomeDiarioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportConnectionString (Web.config)" DbObjectName="deo.acessos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Pagina, Ano, Mes, Dia, Hora, SUM(Qtd) AS qtd
FROM            acessos
WHERE        (Ano = @ano) AND (Mes = @mes) AND (Dia = @dia)
GROUP BY Pagina, Ano, Mes, Dia, Hora
HAVING        (Pagina = 'Home')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ano" ColumnName="Ano" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="mes" ColumnName="Mes" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@mes" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Mes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="dia" ColumnName="Dia" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@dia" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Dia" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pagina" DataSetColumn="Pagina" />
              <Mapping SourceColumn="Ano" DataSetColumn="Ano" />
              <Mapping SourceColumn="Mes" DataSetColumn="Mes" />
              <Mapping SourceColumn="Dia" DataSetColumn="Dia" />
              <Mapping SourceColumn="Hora" DataSetColumn="Hora" />
              <Mapping SourceColumn="qtd" DataSetColumn="qtd" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HomeMensalTableAdapter" GeneratorDataComponentClassName="HomeMensalTableAdapter" Name="HomeMensal" UserDataComponentName="HomeMensalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportConnectionString (Web.config)" DbObjectName="deo.acessos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Pagina, Ano, Mes, Dia, SUM(Qtd) AS qtd
FROM            acessos
WHERE        (Ano = @ano) AND (Mes = @mes)
GROUP BY Pagina, Ano, Mes, Dia
HAVING        (Pagina = 'Home')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ano" ColumnName="Ano" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="mes" ColumnName="Mes" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@mes" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Mes" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pagina" DataSetColumn="Pagina" />
              <Mapping SourceColumn="Ano" DataSetColumn="Ano" />
              <Mapping SourceColumn="Mes" DataSetColumn="Mes" />
              <Mapping SourceColumn="Dia" DataSetColumn="Dia" />
              <Mapping SourceColumn="qtd" DataSetColumn="qtd" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HomeAnualTableAdapter" GeneratorDataComponentClassName="HomeAnualTableAdapter" Name="HomeAnual" UserDataComponentName="HomeAnualTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportConnectionString (Web.config)" DbObjectName="deo.acessos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Pagina, Ano, Mes, SUM(Qtd) AS qtd
FROM            acessos
WHERE        (Ano = @ano)
GROUP BY Pagina, Ano, Mes
HAVING        (Pagina = 'Home')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ano" ColumnName="Ano" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pagina" DataSetColumn="Pagina" />
              <Mapping SourceColumn="Ano" DataSetColumn="Ano" />
              <Mapping SourceColumn="Mes" DataSetColumn="Mes" />
              <Mapping SourceColumn="qtd" DataSetColumn="qtd" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PaginaDiarioTableAdapter" GeneratorDataComponentClassName="PaginaDiarioTableAdapter" Name="PaginaDiario" UserDataComponentName="PaginaDiarioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportConnectionString (Web.config)" DbObjectName="deo.acessos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Pagina, Ano, Mes, Dia, Hora, SUM(Qtd) AS qtd
FROM            acessos
WHERE        (Ano = @ano) AND (Mes = @mes) AND (Dia = @dia) AND (Pagina &lt;&gt; 'Home') AND (IdCategoria IS NULL) AND (IdFamilia IS NULL) AND (IdSubFamilia IS NULL) 
                         AND (IdProduto IS NULL)
GROUP BY Pagina, Ano, Mes, Dia, Hora</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ano" ColumnName="Ano" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="mes" ColumnName="Mes" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@mes" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Mes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="dia" ColumnName="Dia" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@dia" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Dia" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pagina" DataSetColumn="Pagina" />
              <Mapping SourceColumn="Ano" DataSetColumn="Ano" />
              <Mapping SourceColumn="Mes" DataSetColumn="Mes" />
              <Mapping SourceColumn="Dia" DataSetColumn="Dia" />
              <Mapping SourceColumn="Hora" DataSetColumn="Hora" />
              <Mapping SourceColumn="qtd" DataSetColumn="qtd" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PaginaMensalTableAdapter" GeneratorDataComponentClassName="PaginaMensalTableAdapter" Name="PaginaMensal" UserDataComponentName="PaginaMensalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportConnectionString (Web.config)" DbObjectName="deo.acessos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Pagina, Ano, Mes, Dia, SUM(Qtd) AS qtd
FROM            acessos
WHERE        (Ano = @ano) AND (Mes = @mes) AND (Pagina &lt;&gt; 'Home') AND (IdCategoria IS NULL) AND (IdFamilia IS NULL) AND (IdSubFamilia IS NULL) AND 
                         (IdProduto IS NULL)
GROUP BY Pagina, Ano, Mes, Dia</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ano" ColumnName="Ano" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="mes" ColumnName="Mes" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@mes" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Mes" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pagina" DataSetColumn="Pagina" />
              <Mapping SourceColumn="Ano" DataSetColumn="Ano" />
              <Mapping SourceColumn="Mes" DataSetColumn="Mes" />
              <Mapping SourceColumn="Dia" DataSetColumn="Dia" />
              <Mapping SourceColumn="qtd" DataSetColumn="qtd" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PaginaAnualTableAdapter" GeneratorDataComponentClassName="PaginaAnualTableAdapter" Name="PaginaAnual" UserDataComponentName="PaginaAnualTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportConnectionString (Web.config)" DbObjectName="deo.acessos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Pagina, Ano, Mes, SUM(Qtd) AS qtd
FROM            acessos
WHERE        (Ano = @ano) AND (Pagina &lt;&gt; 'Home') AND (IdCategoria IS NULL) AND (IdFamilia IS NULL) AND (IdSubFamilia IS NULL) AND (IdProduto IS NULL)
GROUP BY Pagina, Ano, Mes</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ano" ColumnName="Ano" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pagina" DataSetColumn="Pagina" />
              <Mapping SourceColumn="Ano" DataSetColumn="Ano" />
              <Mapping SourceColumn="Mes" DataSetColumn="Mes" />
              <Mapping SourceColumn="qtd" DataSetColumn="qtd" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CategoriaMensalTableAdapter" GeneratorDataComponentClassName="CategoriaMensalTableAdapter" Name="CategoriaMensal" UserDataComponentName="CategoriaMensalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        acessos.Pagina, acessos.Ano, acessos.Mes, acessos.Dia, SUM(acessos.Qtd) AS qtd, categoria.Categoria
FROM            acessos INNER JOIN
                         categoria ON acessos.IdCategoria = categoria.IdCategoria
WHERE        (acessos.Ano = @ano) AND (acessos.Mes = @mes) AND (acessos.IdCategoria IS NOT NULL)
GROUP BY acessos.Pagina, acessos.Ano, acessos.Mes, acessos.Dia, categoria.Categoria</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ano" ColumnName="Ano" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="mes" ColumnName="Mes" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@mes" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Mes" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pagina" DataSetColumn="Pagina" />
              <Mapping SourceColumn="Ano" DataSetColumn="Ano" />
              <Mapping SourceColumn="Mes" DataSetColumn="Mes" />
              <Mapping SourceColumn="Dia" DataSetColumn="Dia" />
              <Mapping SourceColumn="qtd" DataSetColumn="qtd" />
              <Mapping SourceColumn="Categoria" DataSetColumn="Categoria" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FamiliaMensalTableAdapter" GeneratorDataComponentClassName="FamiliaMensalTableAdapter" Name="FamiliaMensal" UserDataComponentName="FamiliaMensalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        acessos.Pagina, acessos.Ano, acessos.Mes, acessos.Dia, SUM(acessos.Qtd) AS qtd, familia.Familia
FROM            acessos INNER JOIN
                         familia ON acessos.IdFamilia = familia.IdFamilia
WHERE        (acessos.Ano = @ano) AND (acessos.Mes = @mes) AND (acessos.IdFamilia IS NOT NULL)
GROUP BY acessos.Pagina, acessos.Ano, acessos.Mes, acessos.Dia, familia.Familia</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ano" ColumnName="Ano" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="mes" ColumnName="Mes" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@mes" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Mes" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pagina" DataSetColumn="Pagina" />
              <Mapping SourceColumn="Ano" DataSetColumn="Ano" />
              <Mapping SourceColumn="Mes" DataSetColumn="Mes" />
              <Mapping SourceColumn="Dia" DataSetColumn="Dia" />
              <Mapping SourceColumn="qtd" DataSetColumn="qtd" />
              <Mapping SourceColumn="Familia" DataSetColumn="Familia" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SubFamiliaMensalTableAdapter" GeneratorDataComponentClassName="SubFamiliaMensalTableAdapter" Name="SubFamiliaMensal" UserDataComponentName="SubFamiliaMensalTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        acessos.Pagina, acessos.Ano, acessos.Mes, acessos.Dia, SUM(acessos.Qtd) AS qtd, subfamilia.SubFamilia
FROM            acessos INNER JOIN
                         subfamilia ON acessos.IdSubFamilia = subfamilia.IdSubFamilia
WHERE        (acessos.Ano = @ano) AND (acessos.Mes = @mes) AND (acessos.IdSubFamilia IS NOT NULL)
GROUP BY acessos.Pagina, acessos.Ano, acessos.Mes, acessos.Dia, subfamilia.SubFamilia</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="ano" ColumnName="Ano" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@ano" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Ano" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="mes" ColumnName="Mes" DataSourceName="deo.acessos" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@mes" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Mes" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Pagina" DataSetColumn="Pagina" />
              <Mapping SourceColumn="Ano" DataSetColumn="Ano" />
              <Mapping SourceColumn="Mes" DataSetColumn="Mes" />
              <Mapping SourceColumn="Dia" DataSetColumn="Dia" />
              <Mapping SourceColumn="qtd" DataSetColumn="qtd" />
              <Mapping SourceColumn="SubFamilia" DataSetColumn="SubFamilia" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="OrcamentoDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msdata:EnforceConstraints="False" msprop:Generator_UserDSName="OrcamentoDataSet" msprop:Generator_DataSetName="OrcamentoDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="OrcamentoHeader" msprop:Generator_UserTableName="OrcamentoHeader" msprop:Generator_RowDeletedName="OrcamentoHeaderRowDeleted" msprop:Generator_RowChangedName="OrcamentoHeaderRowChanged" msprop:Generator_RowClassName="OrcamentoHeaderRow" msprop:Generator_RowChangingName="OrcamentoHeaderRowChanging" msprop:Generator_RowEvArgName="OrcamentoHeaderRowChangeEvent" msprop:Generator_RowEvHandlerName="OrcamentoHeaderRowChangeEventHandler" msprop:Generator_TableClassName="OrcamentoHeaderDataTable" msprop:Generator_TableVarName="tableOrcamentoHeader" msprop:Generator_RowDeletingName="OrcamentoHeaderRowDeleting" msprop:Generator_TablePropName="OrcamentoHeader">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdOrcamento" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdOrcamento" msprop:Generator_ColumnPropNameInRow="IdOrcamento" msprop:Generator_ColumnVarNameInTable="columnIdOrcamento" msprop:Generator_ColumnPropNameInTable="IdOrcamentoColumn" type="xs:int" />
              <xs:element name="IdCliente" msprop:Generator_UserColumnName="IdCliente" msprop:Generator_ColumnPropNameInRow="IdCliente" msprop:Generator_ColumnVarNameInTable="columnIdCliente" msprop:Generator_ColumnPropNameInTable="IdClienteColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DataSolic" msprop:Generator_UserColumnName="DataSolic" msprop:Generator_ColumnPropNameInRow="DataSolic" msprop:Generator_ColumnVarNameInTable="columnDataSolic" msprop:Generator_ColumnPropNameInTable="DataSolicColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DataExec" msprop:Generator_UserColumnName="DataExec" msprop:Generator_ColumnPropNameInRow="DataExec" msprop:Generator_ColumnVarNameInTable="columnDataExec" msprop:Generator_ColumnPropNameInTable="DataExecColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DataValid" msprop:Generator_UserColumnName="DataValid" msprop:Generator_ColumnPropNameInRow="DataValid" msprop:Generator_ColumnVarNameInTable="columnDataValid" msprop:Generator_ColumnPropNameInTable="DataValidColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Obs" msprop:Generator_UserColumnName="Obs" msprop:Generator_ColumnPropNameInRow="Obs" msprop:Generator_ColumnVarNameInTable="columnObs" msprop:Generator_ColumnPropNameInTable="ObsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="65535" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Tipo" msprop:Generator_UserColumnName="Tipo" msprop:Generator_ColumnPropNameInRow="Tipo" msprop:Generator_ColumnVarNameInTable="columnTipo" msprop:Generator_ColumnPropNameInTable="TipoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInTable="NomeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sobrenome" msprop:Generator_UserColumnName="Sobrenome" msprop:Generator_ColumnPropNameInRow="Sobrenome" msprop:Generator_ColumnVarNameInTable="columnSobrenome" msprop:Generator_ColumnPropNameInTable="SobrenomeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NomePJ" msprop:Generator_UserColumnName="NomePJ" msprop:Generator_ColumnPropNameInRow="NomePJ" msprop:Generator_ColumnVarNameInTable="columnNomePJ" msprop:Generator_ColumnPropNameInTable="NomePJColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OrcamentoItens" msprop:Generator_UserTableName="OrcamentoItens" msprop:Generator_RowDeletedName="OrcamentoItensRowDeleted" msprop:Generator_RowChangedName="OrcamentoItensRowChanged" msprop:Generator_RowClassName="OrcamentoItensRow" msprop:Generator_RowChangingName="OrcamentoItensRowChanging" msprop:Generator_RowEvArgName="OrcamentoItensRowChangeEvent" msprop:Generator_RowEvHandlerName="OrcamentoItensRowChangeEventHandler" msprop:Generator_TableClassName="OrcamentoItensDataTable" msprop:Generator_TableVarName="tableOrcamentoItens" msprop:Generator_RowDeletingName="OrcamentoItensRowDeleting" msprop:Generator_TablePropName="OrcamentoItens">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdOrcamentoItem" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdOrcamentoItem" msprop:Generator_ColumnPropNameInRow="IdOrcamentoItem" msprop:Generator_ColumnVarNameInTable="columnIdOrcamentoItem" msprop:Generator_ColumnPropNameInTable="IdOrcamentoItemColumn" type="xs:int" />
              <xs:element name="SubFamilia" msprop:Generator_UserColumnName="SubFamilia" msprop:Generator_ColumnPropNameInRow="SubFamilia" msprop:Generator_ColumnVarNameInTable="columnSubFamilia" msprop:Generator_ColumnPropNameInTable="SubFamiliaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Referencia" msprop:Generator_UserColumnName="Referencia" msprop:Generator_ColumnPropNameInRow="Referencia" msprop:Generator_ColumnVarNameInTable="columnReferencia" msprop:Generator_ColumnPropNameInTable="ReferenciaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Produto" msprop:Generator_UserColumnName="Produto" msprop:Generator_ColumnPropNameInRow="Produto" msprop:Generator_ColumnVarNameInTable="columnProduto" msprop:Generator_ColumnPropNameInTable="ProdutoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Quantidade" msprop:Generator_UserColumnName="Quantidade" msprop:Generator_ColumnPropNameInRow="Quantidade" msprop:Generator_ColumnVarNameInTable="columnQuantidade" msprop:Generator_ColumnPropNameInTable="QuantidadeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Unidade" msprop:Generator_UserColumnName="Unidade" msprop:Generator_ColumnPropNameInRow="Unidade" msprop:Generator_ColumnVarNameInTable="columnUnidade" msprop:Generator_ColumnPropNameInTable="UnidadeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValorUnit" msprop:Generator_UserColumnName="ValorUnit" msprop:Generator_ColumnPropNameInRow="ValorUnit" msprop:Generator_ColumnVarNameInTable="columnValorUnit" msprop:Generator_ColumnPropNameInTable="ValorUnitColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ValorTotal" msprop:Generator_UserColumnName="ValorTotal" msprop:Generator_ColumnPropNameInRow="ValorTotal" msprop:Generator_ColumnVarNameInTable="columnValorTotal" msprop:Generator_ColumnPropNameInTable="ValorTotalColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Medida" msprop:Generator_UserColumnName="Medida" msprop:Generator_ColumnPropNameInRow="Medida" msprop:Generator_ColumnVarNameInTable="columnMedida" msprop:Generator_ColumnPropNameInTable="MedidaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Embalagem" msprop:Generator_UserColumnName="Embalagem" msprop:Generator_ColumnPropNameInRow="Embalagem" msprop:Generator_ColumnVarNameInTable="columnEmbalagem" msprop:Generator_ColumnPropNameInTable="EmbalagemColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Caixa" msprop:Generator_UserColumnName="Caixa" msprop:Generator_ColumnPropNameInRow="Caixa" msprop:Generator_ColumnVarNameInTable="columnCaixa" msprop:Generator_ColumnPropNameInTable="CaixaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cor" msprop:Generator_UserColumnName="Cor" msprop:Generator_ColumnPropNameInRow="Cor" msprop:Generator_ColumnVarNameInTable="columnCor" msprop:Generator_ColumnPropNameInTable="CorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IPI" msprop:Generator_UserColumnName="IPI" msprop:Generator_ColumnPropNameInRow="IPI" msprop:Generator_ColumnVarNameInTable="columnIPI" msprop:Generator_ColumnPropNameInTable="IPIColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Obs" msprop:Generator_UserColumnName="Obs" msprop:Generator_ColumnPropNameInRow="Obs" msprop:Generator_ColumnVarNameInTable="columnObs" msprop:Generator_ColumnPropNameInTable="ObsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="HomeDiario" msprop:Generator_UserTableName="HomeDiario" msprop:Generator_RowDeletedName="HomeDiarioRowDeleted" msprop:Generator_RowChangedName="HomeDiarioRowChanged" msprop:Generator_RowClassName="HomeDiarioRow" msprop:Generator_RowChangingName="HomeDiarioRowChanging" msprop:Generator_RowEvArgName="HomeDiarioRowChangeEvent" msprop:Generator_RowEvHandlerName="HomeDiarioRowChangeEventHandler" msprop:Generator_TableClassName="HomeDiarioDataTable" msprop:Generator_TableVarName="tableHomeDiario" msprop:Generator_RowDeletingName="HomeDiarioRowDeleting" msprop:Generator_TablePropName="HomeDiario">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pagina" msprop:Generator_UserColumnName="Pagina" msprop:Generator_ColumnVarNameInTable="columnPagina" msprop:Generator_ColumnPropNameInRow="Pagina" msprop:Generator_ColumnPropNameInTable="PaginaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ano" msprop:Generator_UserColumnName="Ano" msprop:Generator_ColumnVarNameInTable="columnAno" msprop:Generator_ColumnPropNameInRow="Ano" msprop:Generator_ColumnPropNameInTable="AnoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Mes" msprop:Generator_UserColumnName="Mes" msprop:Generator_ColumnVarNameInTable="columnMes" msprop:Generator_ColumnPropNameInRow="Mes" msprop:Generator_ColumnPropNameInTable="MesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Dia" msprop:Generator_UserColumnName="Dia" msprop:Generator_ColumnVarNameInTable="columnDia" msprop:Generator_ColumnPropNameInRow="Dia" msprop:Generator_ColumnPropNameInTable="DiaColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Hora" msprop:Generator_UserColumnName="Hora" msprop:Generator_ColumnVarNameInTable="columnHora" msprop:Generator_ColumnPropNameInRow="Hora" msprop:Generator_ColumnPropNameInTable="HoraColumn" type="xs:int" minOccurs="0" />
              <xs:element name="qtd" msprop:Generator_UserColumnName="qtd" msprop:Generator_ColumnVarNameInTable="columnqtd" msprop:Generator_ColumnPropNameInRow="qtd" msprop:Generator_ColumnPropNameInTable="qtdColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="HomeMensal" msprop:Generator_UserTableName="HomeMensal" msprop:Generator_RowDeletedName="HomeMensalRowDeleted" msprop:Generator_RowChangedName="HomeMensalRowChanged" msprop:Generator_RowClassName="HomeMensalRow" msprop:Generator_RowChangingName="HomeMensalRowChanging" msprop:Generator_RowEvArgName="HomeMensalRowChangeEvent" msprop:Generator_RowEvHandlerName="HomeMensalRowChangeEventHandler" msprop:Generator_TableClassName="HomeMensalDataTable" msprop:Generator_TableVarName="tableHomeMensal" msprop:Generator_RowDeletingName="HomeMensalRowDeleting" msprop:Generator_TablePropName="HomeMensal">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pagina" msprop:Generator_UserColumnName="Pagina" msprop:Generator_ColumnVarNameInTable="columnPagina" msprop:Generator_ColumnPropNameInRow="Pagina" msprop:Generator_ColumnPropNameInTable="PaginaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ano" msprop:Generator_UserColumnName="Ano" msprop:Generator_ColumnVarNameInTable="columnAno" msprop:Generator_ColumnPropNameInRow="Ano" msprop:Generator_ColumnPropNameInTable="AnoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Mes" msprop:Generator_UserColumnName="Mes" msprop:Generator_ColumnVarNameInTable="columnMes" msprop:Generator_ColumnPropNameInRow="Mes" msprop:Generator_ColumnPropNameInTable="MesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Dia" msprop:Generator_UserColumnName="Dia" msprop:Generator_ColumnVarNameInTable="columnDia" msprop:Generator_ColumnPropNameInRow="Dia" msprop:Generator_ColumnPropNameInTable="DiaColumn" type="xs:int" minOccurs="0" />
              <xs:element name="qtd" msprop:Generator_UserColumnName="qtd" msprop:Generator_ColumnVarNameInTable="columnqtd" msprop:Generator_ColumnPropNameInRow="qtd" msprop:Generator_ColumnPropNameInTable="qtdColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="HomeAnual" msprop:Generator_UserTableName="HomeAnual" msprop:Generator_RowDeletedName="HomeAnualRowDeleted" msprop:Generator_RowChangedName="HomeAnualRowChanged" msprop:Generator_RowClassName="HomeAnualRow" msprop:Generator_RowChangingName="HomeAnualRowChanging" msprop:Generator_RowEvArgName="HomeAnualRowChangeEvent" msprop:Generator_RowEvHandlerName="HomeAnualRowChangeEventHandler" msprop:Generator_TableClassName="HomeAnualDataTable" msprop:Generator_TableVarName="tableHomeAnual" msprop:Generator_RowDeletingName="HomeAnualRowDeleting" msprop:Generator_TablePropName="HomeAnual">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pagina" msprop:Generator_UserColumnName="Pagina" msprop:Generator_ColumnVarNameInTable="columnPagina" msprop:Generator_ColumnPropNameInRow="Pagina" msprop:Generator_ColumnPropNameInTable="PaginaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ano" msprop:Generator_UserColumnName="Ano" msprop:Generator_ColumnVarNameInTable="columnAno" msprop:Generator_ColumnPropNameInRow="Ano" msprop:Generator_ColumnPropNameInTable="AnoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Mes" msprop:Generator_UserColumnName="Mes" msprop:Generator_ColumnVarNameInTable="columnMes" msprop:Generator_ColumnPropNameInRow="Mes" msprop:Generator_ColumnPropNameInTable="MesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="qtd" msprop:Generator_UserColumnName="qtd" msprop:Generator_ColumnVarNameInTable="columnqtd" msprop:Generator_ColumnPropNameInRow="qtd" msprop:Generator_ColumnPropNameInTable="qtdColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PaginaDiario" msprop:Generator_UserTableName="PaginaDiario" msprop:Generator_RowDeletedName="PaginaDiarioRowDeleted" msprop:Generator_RowChangedName="PaginaDiarioRowChanged" msprop:Generator_RowClassName="PaginaDiarioRow" msprop:Generator_RowChangingName="PaginaDiarioRowChanging" msprop:Generator_RowEvArgName="PaginaDiarioRowChangeEvent" msprop:Generator_RowEvHandlerName="PaginaDiarioRowChangeEventHandler" msprop:Generator_TableClassName="PaginaDiarioDataTable" msprop:Generator_TableVarName="tablePaginaDiario" msprop:Generator_RowDeletingName="PaginaDiarioRowDeleting" msprop:Generator_TablePropName="PaginaDiario">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pagina" msprop:Generator_UserColumnName="Pagina" msprop:Generator_ColumnVarNameInTable="columnPagina" msprop:Generator_ColumnPropNameInRow="Pagina" msprop:Generator_ColumnPropNameInTable="PaginaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ano" msprop:Generator_UserColumnName="Ano" msprop:Generator_ColumnVarNameInTable="columnAno" msprop:Generator_ColumnPropNameInRow="Ano" msprop:Generator_ColumnPropNameInTable="AnoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Mes" msprop:Generator_UserColumnName="Mes" msprop:Generator_ColumnVarNameInTable="columnMes" msprop:Generator_ColumnPropNameInRow="Mes" msprop:Generator_ColumnPropNameInTable="MesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Dia" msprop:Generator_UserColumnName="Dia" msprop:Generator_ColumnVarNameInTable="columnDia" msprop:Generator_ColumnPropNameInRow="Dia" msprop:Generator_ColumnPropNameInTable="DiaColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Hora" msprop:Generator_UserColumnName="Hora" msprop:Generator_ColumnVarNameInTable="columnHora" msprop:Generator_ColumnPropNameInRow="Hora" msprop:Generator_ColumnPropNameInTable="HoraColumn" type="xs:int" minOccurs="0" />
              <xs:element name="qtd" msprop:Generator_UserColumnName="qtd" msprop:Generator_ColumnVarNameInTable="columnqtd" msprop:Generator_ColumnPropNameInRow="qtd" msprop:Generator_ColumnPropNameInTable="qtdColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PaginaMensal" msprop:Generator_UserTableName="PaginaMensal" msprop:Generator_RowDeletedName="PaginaMensalRowDeleted" msprop:Generator_RowChangedName="PaginaMensalRowChanged" msprop:Generator_RowClassName="PaginaMensalRow" msprop:Generator_RowChangingName="PaginaMensalRowChanging" msprop:Generator_RowEvArgName="PaginaMensalRowChangeEvent" msprop:Generator_RowEvHandlerName="PaginaMensalRowChangeEventHandler" msprop:Generator_TableClassName="PaginaMensalDataTable" msprop:Generator_TableVarName="tablePaginaMensal" msprop:Generator_RowDeletingName="PaginaMensalRowDeleting" msprop:Generator_TablePropName="PaginaMensal">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pagina" msprop:Generator_UserColumnName="Pagina" msprop:Generator_ColumnVarNameInTable="columnPagina" msprop:Generator_ColumnPropNameInRow="Pagina" msprop:Generator_ColumnPropNameInTable="PaginaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ano" msprop:Generator_UserColumnName="Ano" msprop:Generator_ColumnVarNameInTable="columnAno" msprop:Generator_ColumnPropNameInRow="Ano" msprop:Generator_ColumnPropNameInTable="AnoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Mes" msprop:Generator_UserColumnName="Mes" msprop:Generator_ColumnVarNameInTable="columnMes" msprop:Generator_ColumnPropNameInRow="Mes" msprop:Generator_ColumnPropNameInTable="MesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Dia" msprop:Generator_UserColumnName="Dia" msprop:Generator_ColumnVarNameInTable="columnDia" msprop:Generator_ColumnPropNameInRow="Dia" msprop:Generator_ColumnPropNameInTable="DiaColumn" type="xs:int" minOccurs="0" />
              <xs:element name="qtd" msprop:Generator_UserColumnName="qtd" msprop:Generator_ColumnVarNameInTable="columnqtd" msprop:Generator_ColumnPropNameInRow="qtd" msprop:Generator_ColumnPropNameInTable="qtdColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PaginaAnual" msprop:Generator_UserTableName="PaginaAnual" msprop:Generator_RowDeletedName="PaginaAnualRowDeleted" msprop:Generator_TableClassName="PaginaAnualDataTable" msprop:Generator_RowChangedName="PaginaAnualRowChanged" msprop:Generator_RowClassName="PaginaAnualRow" msprop:Generator_RowChangingName="PaginaAnualRowChanging" msprop:Generator_RowEvArgName="PaginaAnualRowChangeEvent" msprop:Generator_RowEvHandlerName="PaginaAnualRowChangeEventHandler" msprop:Generator_TablePropName="PaginaAnual" msprop:Generator_TableVarName="tablePaginaAnual" msprop:Generator_RowDeletingName="PaginaAnualRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pagina" msprop:Generator_UserColumnName="Pagina" msprop:Generator_ColumnPropNameInRow="Pagina" msprop:Generator_ColumnVarNameInTable="columnPagina" msprop:Generator_ColumnPropNameInTable="PaginaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ano" msprop:Generator_UserColumnName="Ano" msprop:Generator_ColumnPropNameInRow="Ano" msprop:Generator_ColumnVarNameInTable="columnAno" msprop:Generator_ColumnPropNameInTable="AnoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Mes" msprop:Generator_UserColumnName="Mes" msprop:Generator_ColumnPropNameInRow="Mes" msprop:Generator_ColumnVarNameInTable="columnMes" msprop:Generator_ColumnPropNameInTable="MesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="qtd" msprop:Generator_UserColumnName="qtd" msprop:Generator_ColumnPropNameInRow="qtd" msprop:Generator_ColumnVarNameInTable="columnqtd" msprop:Generator_ColumnPropNameInTable="qtdColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CategoriaMensal" msprop:Generator_UserTableName="CategoriaMensal" msprop:Generator_RowDeletedName="CategoriaMensalRowDeleted" msprop:Generator_TableClassName="CategoriaMensalDataTable" msprop:Generator_RowChangedName="CategoriaMensalRowChanged" msprop:Generator_RowClassName="CategoriaMensalRow" msprop:Generator_RowChangingName="CategoriaMensalRowChanging" msprop:Generator_RowEvArgName="CategoriaMensalRowChangeEvent" msprop:Generator_RowEvHandlerName="CategoriaMensalRowChangeEventHandler" msprop:Generator_TablePropName="CategoriaMensal" msprop:Generator_TableVarName="tableCategoriaMensal" msprop:Generator_RowDeletingName="CategoriaMensalRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pagina" msprop:Generator_UserColumnName="Pagina" msprop:Generator_ColumnPropNameInRow="Pagina" msprop:Generator_ColumnVarNameInTable="columnPagina" msprop:Generator_ColumnPropNameInTable="PaginaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ano" msprop:Generator_UserColumnName="Ano" msprop:Generator_ColumnPropNameInRow="Ano" msprop:Generator_ColumnVarNameInTable="columnAno" msprop:Generator_ColumnPropNameInTable="AnoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Mes" msprop:Generator_UserColumnName="Mes" msprop:Generator_ColumnPropNameInRow="Mes" msprop:Generator_ColumnVarNameInTable="columnMes" msprop:Generator_ColumnPropNameInTable="MesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Dia" msprop:Generator_UserColumnName="Dia" msprop:Generator_ColumnPropNameInRow="Dia" msprop:Generator_ColumnVarNameInTable="columnDia" msprop:Generator_ColumnPropNameInTable="DiaColumn" type="xs:int" minOccurs="0" />
              <xs:element name="qtd" msprop:Generator_UserColumnName="qtd" msprop:Generator_ColumnPropNameInRow="qtd" msprop:Generator_ColumnVarNameInTable="columnqtd" msprop:Generator_ColumnPropNameInTable="qtdColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Categoria" msprop:Generator_UserColumnName="Categoria" msprop:Generator_ColumnPropNameInRow="Categoria" msprop:Generator_ColumnVarNameInTable="columnCategoria" msprop:Generator_ColumnPropNameInTable="CategoriaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FamiliaMensal" msprop:Generator_UserTableName="FamiliaMensal" msprop:Generator_RowDeletedName="FamiliaMensalRowDeleted" msprop:Generator_TableClassName="FamiliaMensalDataTable" msprop:Generator_RowChangedName="FamiliaMensalRowChanged" msprop:Generator_RowClassName="FamiliaMensalRow" msprop:Generator_RowChangingName="FamiliaMensalRowChanging" msprop:Generator_RowEvArgName="FamiliaMensalRowChangeEvent" msprop:Generator_RowEvHandlerName="FamiliaMensalRowChangeEventHandler" msprop:Generator_TablePropName="FamiliaMensal" msprop:Generator_TableVarName="tableFamiliaMensal" msprop:Generator_RowDeletingName="FamiliaMensalRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pagina" msprop:Generator_UserColumnName="Pagina" msprop:Generator_ColumnPropNameInRow="Pagina" msprop:Generator_ColumnVarNameInTable="columnPagina" msprop:Generator_ColumnPropNameInTable="PaginaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ano" msprop:Generator_UserColumnName="Ano" msprop:Generator_ColumnPropNameInRow="Ano" msprop:Generator_ColumnVarNameInTable="columnAno" msprop:Generator_ColumnPropNameInTable="AnoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Mes" msprop:Generator_UserColumnName="Mes" msprop:Generator_ColumnPropNameInRow="Mes" msprop:Generator_ColumnVarNameInTable="columnMes" msprop:Generator_ColumnPropNameInTable="MesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Dia" msprop:Generator_UserColumnName="Dia" msprop:Generator_ColumnPropNameInRow="Dia" msprop:Generator_ColumnVarNameInTable="columnDia" msprop:Generator_ColumnPropNameInTable="DiaColumn" type="xs:int" minOccurs="0" />
              <xs:element name="qtd" msprop:Generator_UserColumnName="qtd" msprop:Generator_ColumnPropNameInRow="qtd" msprop:Generator_ColumnVarNameInTable="columnqtd" msprop:Generator_ColumnPropNameInTable="qtdColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Familia" msprop:Generator_UserColumnName="Familia" msprop:Generator_ColumnPropNameInRow="Familia" msprop:Generator_ColumnVarNameInTable="columnFamilia" msprop:Generator_ColumnPropNameInTable="FamiliaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SubFamiliaMensal" msprop:Generator_UserTableName="SubFamiliaMensal" msprop:Generator_RowDeletedName="SubFamiliaMensalRowDeleted" msprop:Generator_TableClassName="SubFamiliaMensalDataTable" msprop:Generator_RowChangedName="SubFamiliaMensalRowChanged" msprop:Generator_RowClassName="SubFamiliaMensalRow" msprop:Generator_RowChangingName="SubFamiliaMensalRowChanging" msprop:Generator_RowEvArgName="SubFamiliaMensalRowChangeEvent" msprop:Generator_RowEvHandlerName="SubFamiliaMensalRowChangeEventHandler" msprop:Generator_TablePropName="SubFamiliaMensal" msprop:Generator_TableVarName="tableSubFamiliaMensal" msprop:Generator_RowDeletingName="SubFamiliaMensalRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Pagina" msprop:Generator_UserColumnName="Pagina" msprop:Generator_ColumnPropNameInRow="Pagina" msprop:Generator_ColumnVarNameInTable="columnPagina" msprop:Generator_ColumnPropNameInTable="PaginaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ano" msprop:Generator_UserColumnName="Ano" msprop:Generator_ColumnPropNameInRow="Ano" msprop:Generator_ColumnVarNameInTable="columnAno" msprop:Generator_ColumnPropNameInTable="AnoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Mes" msprop:Generator_UserColumnName="Mes" msprop:Generator_ColumnPropNameInRow="Mes" msprop:Generator_ColumnVarNameInTable="columnMes" msprop:Generator_ColumnPropNameInTable="MesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Dia" msprop:Generator_UserColumnName="Dia" msprop:Generator_ColumnPropNameInRow="Dia" msprop:Generator_ColumnVarNameInTable="columnDia" msprop:Generator_ColumnPropNameInTable="DiaColumn" type="xs:int" minOccurs="0" />
              <xs:element name="qtd" msprop:Generator_UserColumnName="qtd" msprop:Generator_ColumnPropNameInRow="qtd" msprop:Generator_ColumnVarNameInTable="columnqtd" msprop:Generator_ColumnPropNameInTable="qtdColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="SubFamilia" msprop:Generator_UserColumnName="SubFamilia" msprop:Generator_ColumnPropNameInRow="SubFamilia" msprop:Generator_ColumnVarNameInTable="columnSubFamilia" msprop:Generator_ColumnPropNameInTable="SubFamiliaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:OrcamentoHeader" />
      <xs:field xpath="mstns:IdOrcamento" />
    </xs:unique>
    <xs:unique name="OrcamentoItens_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:OrcamentoItens" />
      <xs:field xpath="mstns:IdOrcamentoItem" />
    </xs:unique>
  </xs:element>
</xs:schema>